package com.itic.mall.system.orders.orderJDLeadInto.persistence.model;

import com.itic.appbase.framework.common.persistence.model.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderJDLeadIntoExample extends BaseExample {
    /**
    
     *
     * @mbggenerated
     */
    protected String orderByClause;

    /**
    
     *
     * @mbggenerated
     */
    protected boolean distinct;

    /**
    
     *
     * @mbggenerated
     */
    protected List<Criteria> oredCriteria;

    /**
    
     *
     * @mbggenerated
     */
    public OrderJDLeadIntoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class corresponds to the database table t_order_jd_lead_into
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNull() {
            addCriterion("IS_EFFECTIVE is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNotNull() {
            addCriterion("IS_EFFECTIVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveEqualTo(String value) {
            addCriterion("IS_EFFECTIVE =", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <>", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThan(String value) {
            addCriterion("IS_EFFECTIVE >", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE >=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThan(String value) {
            addCriterion("IS_EFFECTIVE <", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLike(String value) {
            addCriterion("IS_EFFECTIVE like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotLike(String value) {
            addCriterion("IS_EFFECTIVE not like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIn(List<String> values) {
            addCriterion("IS_EFFECTIVE in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotIn(List<String> values) {
            addCriterion("IS_EFFECTIVE not in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE not between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andReorderIsNull() {
            addCriterion("REORDER is null");
            return (Criteria) this;
        }

        public Criteria andReorderIsNotNull() {
            addCriterion("REORDER is not null");
            return (Criteria) this;
        }

        public Criteria andReorderEqualTo(Integer value) {
            addCriterion("REORDER =", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotEqualTo(Integer value) {
            addCriterion("REORDER <>", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThan(Integer value) {
            addCriterion("REORDER >", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThanOrEqualTo(Integer value) {
            addCriterion("REORDER >=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThan(Integer value) {
            addCriterion("REORDER <", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThanOrEqualTo(Integer value) {
            addCriterion("REORDER <=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderIn(List<Integer> values) {
            addCriterion("REORDER in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotIn(List<Integer> values) {
            addCriterion("REORDER not in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderBetween(Integer value1, Integer value2) {
            addCriterion("REORDER between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotBetween(Integer value1, Integer value2) {
            addCriterion("REORDER not between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("NOTE is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("NOTE =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("NOTE <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("NOTE >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("NOTE <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("NOTE <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("NOTE like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("NOTE not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("NOTE in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("NOTE not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("NOTE between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("NOTE not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andOrderDateIsNull() {
            addCriterion("ORDER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andOrderDateIsNotNull() {
            addCriterion("ORDER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDateEqualTo(Date value) {
            addCriterion("ORDER_DATE =", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotEqualTo(Date value) {
            addCriterion("ORDER_DATE <>", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateGreaterThan(Date value) {
            addCriterion("ORDER_DATE >", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ORDER_DATE >=", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateLessThan(Date value) {
            addCriterion("ORDER_DATE <", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateLessThanOrEqualTo(Date value) {
            addCriterion("ORDER_DATE <=", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateIn(List<Date> values) {
            addCriterion("ORDER_DATE in", values, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotIn(List<Date> values) {
            addCriterion("ORDER_DATE not in", values, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateBetween(Date value1, Date value2) {
            addCriterion("ORDER_DATE between", value1, value2, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotBetween(Date value1, Date value2) {
            addCriterion("ORDER_DATE not between", value1, value2, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("ORDER_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("ORDER_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(String value) {
            addCriterion("ORDER_STATUS =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(String value) {
            addCriterion("ORDER_STATUS <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(String value) {
            addCriterion("ORDER_STATUS >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_STATUS >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(String value) {
            addCriterion("ORDER_STATUS <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("ORDER_STATUS <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLike(String value) {
            addCriterion("ORDER_STATUS like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotLike(String value) {
            addCriterion("ORDER_STATUS not like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<String> values) {
            addCriterion("ORDER_STATUS in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<String> values) {
            addCriterion("ORDER_STATUS not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(String value1, String value2) {
            addCriterion("ORDER_STATUS between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(String value1, String value2) {
            addCriterion("ORDER_STATUS not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("USER_ID =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("USER_ID <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("USER_ID >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("USER_ID >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("USER_ID <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("USER_ID <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("USER_ID like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("USER_ID not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("USER_ID in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("USER_ID not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("USER_ID between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("USER_ID not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyIsNull() {
            addCriterion("ORDER_TOTAL_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyIsNotNull() {
            addCriterion("ORDER_TOTAL_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyEqualTo(String value) {
            addCriterion("ORDER_TOTAL_MONEY =", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyNotEqualTo(String value) {
            addCriterion("ORDER_TOTAL_MONEY <>", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyGreaterThan(String value) {
            addCriterion("ORDER_TOTAL_MONEY >", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_TOTAL_MONEY >=", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyLessThan(String value) {
            addCriterion("ORDER_TOTAL_MONEY <", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyLessThanOrEqualTo(String value) {
            addCriterion("ORDER_TOTAL_MONEY <=", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyLike(String value) {
            addCriterion("ORDER_TOTAL_MONEY like", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyNotLike(String value) {
            addCriterion("ORDER_TOTAL_MONEY not like", value, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyIn(List<String> values) {
            addCriterion("ORDER_TOTAL_MONEY in", values, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyNotIn(List<String> values) {
            addCriterion("ORDER_TOTAL_MONEY not in", values, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyBetween(String value1, String value2) {
            addCriterion("ORDER_TOTAL_MONEY between", value1, value2, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderTotalMoneyNotBetween(String value1, String value2) {
            addCriterion("ORDER_TOTAL_MONEY not between", value1, value2, "orderTotalMoney");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountIsNull() {
            addCriterion("ORDER_TOATL_COUNT is null");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountIsNotNull() {
            addCriterion("ORDER_TOATL_COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountEqualTo(String value) {
            addCriterion("ORDER_TOATL_COUNT =", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountNotEqualTo(String value) {
            addCriterion("ORDER_TOATL_COUNT <>", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountGreaterThan(String value) {
            addCriterion("ORDER_TOATL_COUNT >", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_TOATL_COUNT >=", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountLessThan(String value) {
            addCriterion("ORDER_TOATL_COUNT <", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountLessThanOrEqualTo(String value) {
            addCriterion("ORDER_TOATL_COUNT <=", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountLike(String value) {
            addCriterion("ORDER_TOATL_COUNT like", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountNotLike(String value) {
            addCriterion("ORDER_TOATL_COUNT not like", value, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountIn(List<String> values) {
            addCriterion("ORDER_TOATL_COUNT in", values, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountNotIn(List<String> values) {
            addCriterion("ORDER_TOATL_COUNT not in", values, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountBetween(String value1, String value2) {
            addCriterion("ORDER_TOATL_COUNT between", value1, value2, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderToatlCountNotBetween(String value1, String value2) {
            addCriterion("ORDER_TOATL_COUNT not between", value1, value2, "orderToatlCount");
            return (Criteria) this;
        }

        public Criteria andOrderNumIsNull() {
            addCriterion("ORDER_NUM is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumIsNotNull() {
            addCriterion("ORDER_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumEqualTo(String value) {
            addCriterion("ORDER_NUM =", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotEqualTo(String value) {
            addCriterion("ORDER_NUM <>", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumGreaterThan(String value) {
            addCriterion("ORDER_NUM >", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_NUM >=", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumLessThan(String value) {
            addCriterion("ORDER_NUM <", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumLessThanOrEqualTo(String value) {
            addCriterion("ORDER_NUM <=", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumLike(String value) {
            addCriterion("ORDER_NUM like", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotLike(String value) {
            addCriterion("ORDER_NUM not like", value, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumIn(List<String> values) {
            addCriterion("ORDER_NUM in", values, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotIn(List<String> values) {
            addCriterion("ORDER_NUM not in", values, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumBetween(String value1, String value2) {
            addCriterion("ORDER_NUM between", value1, value2, "orderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotBetween(String value1, String value2) {
            addCriterion("ORDER_NUM not between", value1, value2, "orderNum");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanIsNull() {
            addCriterion("IS_JIESUAN is null");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanIsNotNull() {
            addCriterion("IS_JIESUAN is not null");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanEqualTo(String value) {
            addCriterion("IS_JIESUAN =", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanNotEqualTo(String value) {
            addCriterion("IS_JIESUAN <>", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanGreaterThan(String value) {
            addCriterion("IS_JIESUAN >", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanGreaterThanOrEqualTo(String value) {
            addCriterion("IS_JIESUAN >=", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanLessThan(String value) {
            addCriterion("IS_JIESUAN <", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanLessThanOrEqualTo(String value) {
            addCriterion("IS_JIESUAN <=", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanLike(String value) {
            addCriterion("IS_JIESUAN like", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanNotLike(String value) {
            addCriterion("IS_JIESUAN not like", value, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanIn(List<String> values) {
            addCriterion("IS_JIESUAN in", values, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanNotIn(List<String> values) {
            addCriterion("IS_JIESUAN not in", values, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanBetween(String value1, String value2) {
            addCriterion("IS_JIESUAN between", value1, value2, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andIsJiesuanNotBetween(String value1, String value2) {
            addCriterion("IS_JIESUAN not between", value1, value2, "isJiesuan");
            return (Criteria) this;
        }

        public Criteria andMarketProfitIsNull() {
            addCriterion("MARKET_PROFIT is null");
            return (Criteria) this;
        }

        public Criteria andMarketProfitIsNotNull() {
            addCriterion("MARKET_PROFIT is not null");
            return (Criteria) this;
        }

        public Criteria andMarketProfitEqualTo(String value) {
            addCriterion("MARKET_PROFIT =", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitNotEqualTo(String value) {
            addCriterion("MARKET_PROFIT <>", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitGreaterThan(String value) {
            addCriterion("MARKET_PROFIT >", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitGreaterThanOrEqualTo(String value) {
            addCriterion("MARKET_PROFIT >=", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitLessThan(String value) {
            addCriterion("MARKET_PROFIT <", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitLessThanOrEqualTo(String value) {
            addCriterion("MARKET_PROFIT <=", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitLike(String value) {
            addCriterion("MARKET_PROFIT like", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitNotLike(String value) {
            addCriterion("MARKET_PROFIT not like", value, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitIn(List<String> values) {
            addCriterion("MARKET_PROFIT in", values, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitNotIn(List<String> values) {
            addCriterion("MARKET_PROFIT not in", values, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitBetween(String value1, String value2) {
            addCriterion("MARKET_PROFIT between", value1, value2, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andMarketProfitNotBetween(String value1, String value2) {
            addCriterion("MARKET_PROFIT not between", value1, value2, "marketProfit");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("FINISH_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("FINISH_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(String value) {
            addCriterion("FINISH_TIME =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(String value) {
            addCriterion("FINISH_TIME <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(String value) {
            addCriterion("FINISH_TIME >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(String value) {
            addCriterion("FINISH_TIME >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(String value) {
            addCriterion("FINISH_TIME <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(String value) {
            addCriterion("FINISH_TIME <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLike(String value) {
            addCriterion("FINISH_TIME like", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotLike(String value) {
            addCriterion("FINISH_TIME not like", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<String> values) {
            addCriterion("FINISH_TIME in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<String> values) {
            addCriterion("FINISH_TIME not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(String value1, String value2) {
            addCriterion("FINISH_TIME between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(String value1, String value2) {
            addCriterion("FINISH_TIME not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNull() {
            addCriterion("PARENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNotNull() {
            addCriterion("PARENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andParentIdEqualTo(String value) {
            addCriterion("PARENT_ID =", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotEqualTo(String value) {
            addCriterion("PARENT_ID <>", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThan(String value) {
            addCriterion("PARENT_ID >", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThanOrEqualTo(String value) {
            addCriterion("PARENT_ID >=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThan(String value) {
            addCriterion("PARENT_ID <", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThanOrEqualTo(String value) {
            addCriterion("PARENT_ID <=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLike(String value) {
            addCriterion("PARENT_ID like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotLike(String value) {
            addCriterion("PARENT_ID not like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdIn(List<String> values) {
            addCriterion("PARENT_ID in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotIn(List<String> values) {
            addCriterion("PARENT_ID not in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdBetween(String value1, String value2) {
            addCriterion("PARENT_ID between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotBetween(String value1, String value2) {
            addCriterion("PARENT_ID not between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andIsPlusIsNull() {
            addCriterion("IS_PLUS is null");
            return (Criteria) this;
        }

        public Criteria andIsPlusIsNotNull() {
            addCriterion("IS_PLUS is not null");
            return (Criteria) this;
        }

        public Criteria andIsPlusEqualTo(String value) {
            addCriterion("IS_PLUS =", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusNotEqualTo(String value) {
            addCriterion("IS_PLUS <>", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusGreaterThan(String value) {
            addCriterion("IS_PLUS >", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusGreaterThanOrEqualTo(String value) {
            addCriterion("IS_PLUS >=", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusLessThan(String value) {
            addCriterion("IS_PLUS <", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusLessThanOrEqualTo(String value) {
            addCriterion("IS_PLUS <=", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusLike(String value) {
            addCriterion("IS_PLUS like", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusNotLike(String value) {
            addCriterion("IS_PLUS not like", value, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusIn(List<String> values) {
            addCriterion("IS_PLUS in", values, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusNotIn(List<String> values) {
            addCriterion("IS_PLUS not in", values, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusBetween(String value1, String value2) {
            addCriterion("IS_PLUS between", value1, value2, "isPlus");
            return (Criteria) this;
        }

        public Criteria andIsPlusNotBetween(String value1, String value2) {
            addCriterion("IS_PLUS not between", value1, value2, "isPlus");
            return (Criteria) this;
        }

        public Criteria andPopIdIsNull() {
            addCriterion("POP_ID is null");
            return (Criteria) this;
        }

        public Criteria andPopIdIsNotNull() {
            addCriterion("POP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPopIdEqualTo(String value) {
            addCriterion("POP_ID =", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdNotEqualTo(String value) {
            addCriterion("POP_ID <>", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdGreaterThan(String value) {
            addCriterion("POP_ID >", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdGreaterThanOrEqualTo(String value) {
            addCriterion("POP_ID >=", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdLessThan(String value) {
            addCriterion("POP_ID <", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdLessThanOrEqualTo(String value) {
            addCriterion("POP_ID <=", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdLike(String value) {
            addCriterion("POP_ID like", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdNotLike(String value) {
            addCriterion("POP_ID not like", value, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdIn(List<String> values) {
            addCriterion("POP_ID in", values, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdNotIn(List<String> values) {
            addCriterion("POP_ID not in", values, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdBetween(String value1, String value2) {
            addCriterion("POP_ID between", value1, value2, "popId");
            return (Criteria) this;
        }

        public Criteria andPopIdNotBetween(String value1, String value2) {
            addCriterion("POP_ID not between", value1, value2, "popId");
            return (Criteria) this;
        }

        public Criteria andTgwIdIsNull() {
            addCriterion("TGW_ID is null");
            return (Criteria) this;
        }

        public Criteria andTgwIdIsNotNull() {
            addCriterion("TGW_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTgwIdEqualTo(String value) {
            addCriterion("TGW_ID =", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdNotEqualTo(String value) {
            addCriterion("TGW_ID <>", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdGreaterThan(String value) {
            addCriterion("TGW_ID >", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdGreaterThanOrEqualTo(String value) {
            addCriterion("TGW_ID >=", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdLessThan(String value) {
            addCriterion("TGW_ID <", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdLessThanOrEqualTo(String value) {
            addCriterion("TGW_ID <=", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdLike(String value) {
            addCriterion("TGW_ID like", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdNotLike(String value) {
            addCriterion("TGW_ID not like", value, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdIn(List<String> values) {
            addCriterion("TGW_ID in", values, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdNotIn(List<String> values) {
            addCriterion("TGW_ID not in", values, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdBetween(String value1, String value2) {
            addCriterion("TGW_ID between", value1, value2, "tgwId");
            return (Criteria) this;
        }

        public Criteria andTgwIdNotBetween(String value1, String value2) {
            addCriterion("TGW_ID not between", value1, value2, "tgwId");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIsNull() {
            addCriterion("DEVICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIsNotNull() {
            addCriterion("DEVICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeEqualTo(String value) {
            addCriterion("DEVICE_TYPE =", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotEqualTo(String value) {
            addCriterion("DEVICE_TYPE <>", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeGreaterThan(String value) {
            addCriterion("DEVICE_TYPE >", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_TYPE >=", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLessThan(String value) {
            addCriterion("DEVICE_TYPE <", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_TYPE <=", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLike(String value) {
            addCriterion("DEVICE_TYPE like", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotLike(String value) {
            addCriterion("DEVICE_TYPE not like", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIn(List<String> values) {
            addCriterion("DEVICE_TYPE in", values, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotIn(List<String> values) {
            addCriterion("DEVICE_TYPE not in", values, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeBetween(String value1, String value2) {
            addCriterion("DEVICE_TYPE between", value1, value2, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotBetween(String value1, String value2) {
            addCriterion("DEVICE_TYPE not between", value1, value2, "deviceType");
            return (Criteria) this;
        }

        public Criteria andIsCancelIsNull() {
            addCriterion("IS_CANCEL is null");
            return (Criteria) this;
        }

        public Criteria andIsCancelIsNotNull() {
            addCriterion("IS_CANCEL is not null");
            return (Criteria) this;
        }

        public Criteria andIsCancelEqualTo(String value) {
            addCriterion("IS_CANCEL =", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelNotEqualTo(String value) {
            addCriterion("IS_CANCEL <>", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelGreaterThan(String value) {
            addCriterion("IS_CANCEL >", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelGreaterThanOrEqualTo(String value) {
            addCriterion("IS_CANCEL >=", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelLessThan(String value) {
            addCriterion("IS_CANCEL <", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelLessThanOrEqualTo(String value) {
            addCriterion("IS_CANCEL <=", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelLike(String value) {
            addCriterion("IS_CANCEL like", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelNotLike(String value) {
            addCriterion("IS_CANCEL not like", value, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelIn(List<String> values) {
            addCriterion("IS_CANCEL in", values, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelNotIn(List<String> values) {
            addCriterion("IS_CANCEL not in", values, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelBetween(String value1, String value2) {
            addCriterion("IS_CANCEL between", value1, value2, "isCancel");
            return (Criteria) this;
        }

        public Criteria andIsCancelNotBetween(String value1, String value2) {
            addCriterion("IS_CANCEL not between", value1, value2, "isCancel");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("SOURCE =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("SOURCE <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("SOURCE >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("SOURCE >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("SOURCE <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("SOURCE <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("SOURCE like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("SOURCE not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("SOURCE in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("SOURCE not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("SOURCE between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("SOURCE not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andTgwNameIsNull() {
            addCriterion("TGW_NAME is null");
            return (Criteria) this;
        }

        public Criteria andTgwNameIsNotNull() {
            addCriterion("TGW_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andTgwNameEqualTo(String value) {
            addCriterion("TGW_NAME =", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameNotEqualTo(String value) {
            addCriterion("TGW_NAME <>", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameGreaterThan(String value) {
            addCriterion("TGW_NAME >", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameGreaterThanOrEqualTo(String value) {
            addCriterion("TGW_NAME >=", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameLessThan(String value) {
            addCriterion("TGW_NAME <", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameLessThanOrEqualTo(String value) {
            addCriterion("TGW_NAME <=", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameLike(String value) {
            addCriterion("TGW_NAME like", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameNotLike(String value) {
            addCriterion("TGW_NAME not like", value, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameIn(List<String> values) {
            addCriterion("TGW_NAME in", values, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameNotIn(List<String> values) {
            addCriterion("TGW_NAME not in", values, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameBetween(String value1, String value2) {
            addCriterion("TGW_NAME between", value1, value2, "tgwName");
            return (Criteria) this;
        }

        public Criteria andTgwNameNotBetween(String value1, String value2) {
            addCriterion("TGW_NAME not between", value1, value2, "tgwName");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIsNull() {
            addCriterion("YUN_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIsNotNull() {
            addCriterion("YUN_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andYunUserIdEqualTo(String value) {
            addCriterion("YUN_USER_ID =", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotEqualTo(String value) {
            addCriterion("YUN_USER_ID <>", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdGreaterThan(String value) {
            addCriterion("YUN_USER_ID >", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("YUN_USER_ID >=", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLessThan(String value) {
            addCriterion("YUN_USER_ID <", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLessThanOrEqualTo(String value) {
            addCriterion("YUN_USER_ID <=", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLike(String value) {
            addCriterion("YUN_USER_ID like", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotLike(String value) {
            addCriterion("YUN_USER_ID not like", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIn(List<String> values) {
            addCriterion("YUN_USER_ID in", values, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotIn(List<String> values) {
            addCriterion("YUN_USER_ID not in", values, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdBetween(String value1, String value2) {
            addCriterion("YUN_USER_ID between", value1, value2, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotBetween(String value1, String value2) {
            addCriterion("YUN_USER_ID not between", value1, value2, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameIsNull() {
            addCriterion("YUN_USER_NICK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameIsNotNull() {
            addCriterion("YUN_USER_NICK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameEqualTo(String value) {
            addCriterion("YUN_USER_NICK_NAME =", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameNotEqualTo(String value) {
            addCriterion("YUN_USER_NICK_NAME <>", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameGreaterThan(String value) {
            addCriterion("YUN_USER_NICK_NAME >", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameGreaterThanOrEqualTo(String value) {
            addCriterion("YUN_USER_NICK_NAME >=", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameLessThan(String value) {
            addCriterion("YUN_USER_NICK_NAME <", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameLessThanOrEqualTo(String value) {
            addCriterion("YUN_USER_NICK_NAME <=", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameLike(String value) {
            addCriterion("YUN_USER_NICK_NAME like", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameNotLike(String value) {
            addCriterion("YUN_USER_NICK_NAME not like", value, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameIn(List<String> values) {
            addCriterion("YUN_USER_NICK_NAME in", values, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameNotIn(List<String> values) {
            addCriterion("YUN_USER_NICK_NAME not in", values, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameBetween(String value1, String value2) {
            addCriterion("YUN_USER_NICK_NAME between", value1, value2, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andYunUserNickNameNotBetween(String value1, String value2) {
            addCriterion("YUN_USER_NICK_NAME not between", value1, value2, "yunUserNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIsNull() {
            addCriterion("USER_NICK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIsNotNull() {
            addCriterion("USER_NICK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andUserNickNameEqualTo(String value) {
            addCriterion("USER_NICK_NAME =", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotEqualTo(String value) {
            addCriterion("USER_NICK_NAME <>", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameGreaterThan(String value) {
            addCriterion("USER_NICK_NAME >", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameGreaterThanOrEqualTo(String value) {
            addCriterion("USER_NICK_NAME >=", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLessThan(String value) {
            addCriterion("USER_NICK_NAME <", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLessThanOrEqualTo(String value) {
            addCriterion("USER_NICK_NAME <=", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLike(String value) {
            addCriterion("USER_NICK_NAME like", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotLike(String value) {
            addCriterion("USER_NICK_NAME not like", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIn(List<String> values) {
            addCriterion("USER_NICK_NAME in", values, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotIn(List<String> values) {
            addCriterion("USER_NICK_NAME not in", values, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameBetween(String value1, String value2) {
            addCriterion("USER_NICK_NAME between", value1, value2, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotBetween(String value1, String value2) {
            addCriterion("USER_NICK_NAME not between", value1, value2, "userNickName");
            return (Criteria) this;
        }

        public Criteria andCommisionsIsNull() {
            addCriterion("COMMISIONS is null");
            return (Criteria) this;
        }

        public Criteria andCommisionsIsNotNull() {
            addCriterion("COMMISIONS is not null");
            return (Criteria) this;
        }

        public Criteria andCommisionsEqualTo(String value) {
            addCriterion("COMMISIONS =", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsNotEqualTo(String value) {
            addCriterion("COMMISIONS <>", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsGreaterThan(String value) {
            addCriterion("COMMISIONS >", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsGreaterThanOrEqualTo(String value) {
            addCriterion("COMMISIONS >=", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsLessThan(String value) {
            addCriterion("COMMISIONS <", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsLessThanOrEqualTo(String value) {
            addCriterion("COMMISIONS <=", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsLike(String value) {
            addCriterion("COMMISIONS like", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsNotLike(String value) {
            addCriterion("COMMISIONS not like", value, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsIn(List<String> values) {
            addCriterion("COMMISIONS in", values, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsNotIn(List<String> values) {
            addCriterion("COMMISIONS not in", values, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsBetween(String value1, String value2) {
            addCriterion("COMMISIONS between", value1, value2, "commisions");
            return (Criteria) this;
        }

        public Criteria andCommisionsNotBetween(String value1, String value2) {
            addCriterion("COMMISIONS not between", value1, value2, "commisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsIsNull() {
            addCriterion("OVER_COMMISIONS is null");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsIsNotNull() {
            addCriterion("OVER_COMMISIONS is not null");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsEqualTo(String value) {
            addCriterion("OVER_COMMISIONS =", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsNotEqualTo(String value) {
            addCriterion("OVER_COMMISIONS <>", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsGreaterThan(String value) {
            addCriterion("OVER_COMMISIONS >", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsGreaterThanOrEqualTo(String value) {
            addCriterion("OVER_COMMISIONS >=", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsLessThan(String value) {
            addCriterion("OVER_COMMISIONS <", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsLessThanOrEqualTo(String value) {
            addCriterion("OVER_COMMISIONS <=", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsLike(String value) {
            addCriterion("OVER_COMMISIONS like", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsNotLike(String value) {
            addCriterion("OVER_COMMISIONS not like", value, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsIn(List<String> values) {
            addCriterion("OVER_COMMISIONS in", values, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsNotIn(List<String> values) {
            addCriterion("OVER_COMMISIONS not in", values, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsBetween(String value1, String value2) {
            addCriterion("OVER_COMMISIONS between", value1, value2, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andOverCommisionsNotBetween(String value1, String value2) {
            addCriterion("OVER_COMMISIONS not between", value1, value2, "overCommisions");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeIsNull() {
            addCriterion("JIESUAN_TIME is null");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeIsNotNull() {
            addCriterion("JIESUAN_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeEqualTo(Date value) {
            addCriterion("JIESUAN_TIME =", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeNotEqualTo(Date value) {
            addCriterion("JIESUAN_TIME <>", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeGreaterThan(Date value) {
            addCriterion("JIESUAN_TIME >", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("JIESUAN_TIME >=", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeLessThan(Date value) {
            addCriterion("JIESUAN_TIME <", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeLessThanOrEqualTo(Date value) {
            addCriterion("JIESUAN_TIME <=", value, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeIn(List<Date> values) {
            addCriterion("JIESUAN_TIME in", values, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeNotIn(List<Date> values) {
            addCriterion("JIESUAN_TIME not in", values, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeBetween(Date value1, Date value2) {
            addCriterion("JIESUAN_TIME between", value1, value2, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andJiesuanTimeNotBetween(Date value1, Date value2) {
            addCriterion("JIESUAN_TIME not between", value1, value2, "jiesuanTime");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitIsNull() {
            addCriterion("OVER_MARKET_PROFIT is null");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitIsNotNull() {
            addCriterion("OVER_MARKET_PROFIT is not null");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitEqualTo(String value) {
            addCriterion("OVER_MARKET_PROFIT =", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitNotEqualTo(String value) {
            addCriterion("OVER_MARKET_PROFIT <>", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitGreaterThan(String value) {
            addCriterion("OVER_MARKET_PROFIT >", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitGreaterThanOrEqualTo(String value) {
            addCriterion("OVER_MARKET_PROFIT >=", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitLessThan(String value) {
            addCriterion("OVER_MARKET_PROFIT <", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitLessThanOrEqualTo(String value) {
            addCriterion("OVER_MARKET_PROFIT <=", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitLike(String value) {
            addCriterion("OVER_MARKET_PROFIT like", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitNotLike(String value) {
            addCriterion("OVER_MARKET_PROFIT not like", value, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitIn(List<String> values) {
            addCriterion("OVER_MARKET_PROFIT in", values, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitNotIn(List<String> values) {
            addCriterion("OVER_MARKET_PROFIT not in", values, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitBetween(String value1, String value2) {
            addCriterion("OVER_MARKET_PROFIT between", value1, value2, "overMarketProfit");
            return (Criteria) this;
        }

        public Criteria andOverMarketProfitNotBetween(String value1, String value2) {
            addCriterion("OVER_MARKET_PROFIT not between", value1, value2, "overMarketProfit");
            return (Criteria) this;
        }
    }

    /**
     * This class corresponds to the database table t_order_jd_lead_into
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table t_order_jd_lead_into
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value) {
            super();
            this.condition = condition;
            this.value = value;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.betweenValue = true;
        }
    }
}